﻿CREATE PROCEDURE [dbo].[CourseMaterial_Select]
	@FileName nvarchar(250) = null,
	@CourseSemesterId int = null
AS
	SELECT        FileName, FileUrl, CourseSemesterId
	FROM            CourseMaterials
	WHERE        (@CourseSemesterId IS NULL) OR
	                         (CourseSemesterId = @CourseSemesterId)
RETURN 0